Welcome
Welcome to Cute DB Explorer!

Have you ever experienced to type or copy and paste same query statements again and again during development or testing?  Have you ever experienced having difficulties to organize your query statements, stored procedures, etc. in such way that you can easily find them, run them and use them to create more complicated queries and reports?  Have you ever experienced having to open different database browsers or query editors for different databases during development or testing?  Have you ever experienced having to buy expensive software packages or write your won programs just to display reports for your customer support personnel, organizational information sharing and other miscellaneous purposes?  Have you ever concerned your reports been ran by unauthorized personnel?

If your answer is “Yes” to one of above questions and still is, then this software application is absolutely right for you!  Cure DB Explorer solves all the above problems with extremely user-friendly interface, stunning performance and affordable price.  You will be amazed how easy it is to create reports in any kind and distribute user name and password protected reports that can be executed only by authorized personnel anywhere in your network in just minutes, and turn your reports into HTML pages with just few mouse clicks.

Please refer to "Key Features And Benefits" and "How To" sections for more information.


Enter a valid registration key, then press OK button.


Enter a valid data source name. If you don not have a valid DSN, you can use the ODBC Data Source Administrator to create one.


Enter a valid database name. For some relational databases, such as Microsoft Access Database, this field can be blank.


Enter a user name in this field.


Enter a password in this field.


Click this button to bring up the Select Data Source dialog box from which you can select predefined data source name or create a new one from there.


Click this button to start the login process.


Enter a new password for login.


Repeat the new password in the New Password field.


Enter a group name in the edit field or select an existing group name from the dropdown list. It is possible that you are only allowed to select an existing group name from the dropdown list when editing a group is not allowed.


Enter a new description or change the existing description of the group.


This list box contains all reports available for inclusion.


This list box contains all reports that are currently included in the report group.


Enter a report name in the edit field or select an existing report name from the dropdown list. It is possible that you are only allowed to select an existing report name from the dropdown list when editing a report is not allowed.


You can enter new query statements or edit the existing query statements for the report. The query statements can be any standard SQL statements or database specific routines, stored procedure calls or views, etc.


You can enter a new description or edit the existing description of the report.


Click this button to save any changes you made.


Click this button to test-run the report. A new document window that contains the result of report will be created if the test-run is successfully.


How To...

•	Make a new database connection

•	Display table schema

•	Display stored procedure parameter information

•	Execute a query or selection of a query

•	Display and execute query in the query log

•	Display and execute report related to currently logged on server and database

•	Display reports in a report group

•	Set or change administrator user name and password

•	Set or change group user name and password

•	Edit or save a query as a report

•	Edit or save a report group

•	Execute a report in a report group

•	Create and distribute groups of reports for different groups of people in an organization

•	Drop tables or stored procedures from database

•	Delete queries from query logs

•	Delete reports and report groups

•	Search a table, stored procedure, report, report group or any row in a grid

•	Export content in grid to HTML or CSV formats

•	Print content in grid on printer

•	Contact Allegro Software

•	Purchase Cute DB Explorer


Key Features And Benefits

•	Open multiple connections to one more relational database of any kind.  For instance, you can make multiple connections to Oracle, Sybase, MS SQL Server and MS Access Database at same time with single instance of Cute DB Explorer.

•	Tabbed windows for user tables, stored procedures, query logs, and server database related reports.

•	Double-click to retrieve table data, execute report and execute query in the query log.

•	Display table schema and parameter information of stored procedure with selection highlighter flying by.

•	Execute any SQL statements and routines that are appropriate to your connected database, and display retrieved data and messages in separate tabbed windows.

•	Search tables, stored procedures, logged queries, reports and report groups fast and convenient.

•	Create report with or without making connection to a database first.

•	So long as you have good knowledge SQL and other routines, you will be able to create very sophisticated reports.

•	Export or save table data, result of report, table schema and stored procedure parameter information to HTML and CSV formats.

•	Super-easy to use configuration features to make your Cute DB Explorer and exported HTML look very pretty.

•	Print table data, result of report, table schema and stored procedure parameter information on a printer.

•	Assign user name and password to each report group, so only authorized personnel can execute report in that group.

•	Only the application administrators have the rights to create, modify reports and report groups to prevent inexperienced persons to do harm to your database accidentally.

•	Simply distribute the application database file that contains all reports and report groups to other people so others will have the same set of reports and report groups, so people can execute reports they are authorized to.  For example, CEO can execute reports in the group “Sales of the Month”, and everyone can execute the reports in the group “Organization Address Book”.


What Is New

This release of Cute DB Explorer is completely redesigned and implemented based on the previous release.  It has added a rich set of report, organize and security features and benefits to our users.

Please refer to “Key Features And Benefits” and “How To…” sections for more information.


License Agreement and Warranty

License Agreement

You should carefully read the following terms and conditions before using this software.  Unless you have a different license agreement signed with Allegro Software, Inc., your use of this software indicates your complete acceptance of this license agreement, warranty, terms and conditions, and our refund and exchange policy.

For information on distributing the evaluation version of Cute DB Explorer, please refer to "Evaluation License" section for details.

One registered copy of Cute DB Explorer may be installed on one or more computers provided that only one person shall use the software at any given time.

You may access the registered version of Cute DB Explorer through a network, provided that you have obtained individual licenses for the software covering all workstations that will access the software through the network.

This license agreement shall be governed under the laws of the State of New Jersey.

Disclaimer of Warranty

This software and its components are sold AS-IS without warranty as to performance or merchantability or any other warranties whether expressed or implied.

The user must assume the entire risk on his/her own of using this program.

Terms and Conditions

The database of the application shall only be accessed by Cute DB Explorer application.  No other means of accessing the application database shall be allowed.  For instance, if you use tools to view or copy the database and table structures, the action may violate the Terms and Conditions.

Refund and Exchange Policy

We do not give refund for this software we sold under any circumstances.  When we give out the registration key to user we consider that the software is sold, unless the user canceled the order AND notified us prior to releasing the registration key.  If the installation disks are defect we would replace disks free of charge provided that the user must return the defect disks to us.


Order Form
Order Form for Cute DB Explorer

To print this order form, select Print Topic from the File pull-down menu.

To order by check, send this order form and a check or money order to Allegro Software, Inc., P.O.BOX 43, Franklin Park, NJ 08823, USA.  Payments must be in US dollars drawn on a US bank, or you can send international postal money orders in US dollars.

All orders are subject to the Cute DB Explorer "License Agreement and Warranty" and our "Refund and Exchange Policy".

Please allow several business days for us to clear the check

Customer information is considered confidential and will not be shared or distributed to any third party.

Cute DB Explorer:	____ copies at	$49 each =	$_________
New Jersey residents add 6% sales tax:	$_________
**Shipping and handling $20 for each copy (CD only):	$_________
Electronic version only without S&H charges?	__________
Total Payment:	$_________
*Today’s Date:	_______________________________________________
*Customer Name:	_______________________________________________
Company:	_______________________________________________
*Mailing Address:	_______________________________________________
	_______________________________________________
*City, State, Zip:	_______________________________________________
*Country:	_______________________________________________
*Phone:	_______________________________________________
*Email address:	_______________________________________________
Where did you download Cute DB Explorer?	_______________________________________________
Any comments:	_______________________________________________
	_______________________________________________
	_______________________________________________

*These fields are required.

**This charge applies only if you want installation CD and the registration key.  If you want the electronic version only without S&H charges then this charge is avoided and you will get the registration key only.


Ordering Information

You can order Cute DB Explorer online at http://www.allegro-soft.com/ using your credit card.  Or if you prefer you can order it by personal or company check.  Ordering by check "Order Form" is available for print.

When ordering, be sure to fill all the required information clearly and completely especially your email address and phone number since your registration key will be releasing to you via email or phone.

Prior to ordering Cute DB Explorer, you must read and agree on our "Refund and Exchange Policy".


Evaluation License

Evaluation and Registration

Cute DB Explorer is not free software.  Subject to the terms below, you are hereby licensed to use this software for evaluation purposes without charge for a period of 30 days.  If you use this software after the 30-day evaluation period, a registration fee of $49 is required.  Please refer to "Ordering Information" for details.

Unregistered use of Cute DB Explorer after the 30-day evaluation period is in violation of U.S. and international copyright laws.

Distribution

You can make as many copies of the evaluation version of Investment Helper along with Auto Downloader and distribute the copies to anyone as you wish free of charge.

You are specifically prohibited from collecting fees in any form for such copies, however made and distributed; and from distributing the software and/or documentation with other products (commercial or otherwise) without prior written permission from Allegro Software, Inc.

Please also refer to "License Agreement and Warranty" section for more information.


Make a New Database Connection

Select “New Database Connection” menu item from the “File” dropdown menu to bring up “Database Login” dialog box.  Click “Data Source” button to open “Select Data Source” dialog box, then you can select a data source name or create a new one from there.  Or you can enter a data source name in “DSN” field, and supply database name, user ID and password if necessary, then press “Login New” button.

In both case, if a database connection is made then a “Connected Database” window is created, and user tables, stored procedures, query log and reports on the server and database are displayed in tabbed windows.


Display Table Schema

When a connection to database is made, a “Connected Database” window is created.  Click the “User Tables” tab on the tabbed window on the left side of the “Connected Database” window to display all user tables in the database.  When you select a row in that window, table schema information of selected table is displayed in the top right window of the “Connected Database” window.  When selection is changed, table schema information of the new selection is changed accordingly.


Display Stored Procedure Parameter Information

When a connection to database is made, a “Connected Database” window is created.  Click the “Stored Procedures” tab on the tabbed window on the left side of the “Connected Database” window to display all stored procedures in the database.  When you select a row in that window, stored procedure parameter information of selected stored procedure is displayed in the top right window of the Connected Database” window.  When selection is changed, stored procedure parameter information of the new selection is changed accordingly.


Execute a Query or Selection of a Query

When a connection to database is made, a “Connected Database” window is created.  Click the “Query Editor” tab on the tabbed window on the right bottom window of  “Connected Database” window to make the Query Editor window active.  Enter or copy paste query statements, stored procedure or routine in the window.  Then select the “Execute Query” menu item from the “Query” dropdown menu to execute all the query statements in the Query Editor window.  Or select the “Execute Selected Query” menu item from the “Query” dropdown menu to execute selected portion of query statements in the Query Editor window.  Please note that if you want to retrieve data resulted from a stored procedure execution, you need use the syntax {call your stored procedure} to achieve this.  For example, if your stored procedure is called “MyProc”, then the statement is {call MyProc}.


Display and Execute Query in the Query Log

When a connection to database is made, a database “Connected Database” window is created.  Click the “Query Log” tab on the tabbed window on the left side of the “Connected Database” window to display all executed queries under the same server and database.  When you selected a row in that window, query statements of selected query is displayed in the Query Editor window.  When selection is changed, query statements of the new selection is changed accordingly in the Query Editor window.  When you double click the selected query, the query is executed, and retrieved data if any is displayed in the “Query Result” window.


Display and Execute Report Related to Currently Logged on Server and Database

When a connection to database is made, a database “Connected Database” window is created.  Click the “Reports” tab on the tabbed window on the left side of the “Connected Database” window to display all reports under the same server and database.  When you selected a row in that window, query statements of selected report is displayed in the “Query Editor” window.  When selection is changed, query statements of the new selection is changed accordingly in the “Query Editor” window.  When you double click the selected report, the query associated with the report is executed, and retrieved data if any is displayed in the “Query Result” window.


Display Reports in a Report Group

By selecting a report group in the “Report Group List” window, all reports in the selected group are displayed in the “Report List” window.  Double click a report in the “Report List” window, the query associated with report is executed, and the result is displayed in a newly created “Report” window.


Set or Change Administrator User Name and Password

Select the “Change Administrator Password” menu item from the “Tools” dropdown menu to open the “Change Administrator Password” dialog box.  Enter user name, old password, new password, and confirmed new password, then click the “OK” button.


Set or Change Group User Name and Password

In order to set or change group user name and password, you must first logon as administrator.  Then select the “Edit/Add Report Group” menu item from the “Tools” dropdown menu to open the “Edit/Add Report Group” dialog box.  Enter new user name in the “User Name” edit field and password in the “Password” edit field.  Press the “Save/Add” button.


Edit or Save a Query as a Report

Select the “Edit/Add Report” menu item from the “Tools” dropdown menu to open the “Edit/Add Report in Report Group” dialog box. Administrator privilege is required to edit/add reports.  If you have “Connected Database” window open and the “Query Editor” window has the focus, then the content in the “Query Editor” window is used to populate the “Query” edit field in the “Edit/Add Report in Report Group” dialog box.  You may need to supply all necessary information, including data source name, database name, user name and password in order to successfully test-run and save the report.


Edit or Save a Report Group

Select the “Edit/Add Report Group” menu item from the “Tools” dropdown menu to open the “Edit/Add Report Group” dialog box. Administrator privilege is required to edit/add report groups.  Each report group requires its own user name and password.  You can add/remove reports to or from the currently selected report group.


Execute a Report in a Report Group

Select a report group in the “Report Group List” window, and all reports in the selected report group are displayed in the “Report List” window.  Double click any report in the window will execute that report.  A new “Report” window is created to display the retrieved data of the executed report.


Create and Distribute Groups of Reports for Different Groups of People in an Organization

You can create groups of reports locally and set group user name and password for each group, so people who have correct group user name and password can execute the reports in that group.  All information including administrator login name and password, reports and report groups, etc. is stored in the application database file called “Cute DB Explorer .mdb”.

By copying this file to Cute DB Explorer application directory on a user’s machine, the user can execute any report that the user has correct group user name and password for it.  Unless the user has administrator privilege, the user will not be able to change any content in reports and report groups.  The Cute DB Explorer application database file, “Cute DB Explorer.mdb”, can be distributed via email and other means in an organization, and with simple instructions user can easily update their database file so they can have up-to-date reports to run.


Drop Tables or Store Procedures from Database

When a connection to database is made, a “Connected Database” window is created.

Click the “User Tables” tab on the tabbed window on the left side of the “Connected Database” window to display all user tables in the database.  Select one or more tables, then press the “Delete” key.  This action will drop all selected tables one by one with your confirmations.

Click the “Stored Procedures” tab on the tabbed window on the left side of the “Connected Database” window to display all stored procedures in the database.  Select one or more stored procedures, then press the “Delete” key.  This action will drop all selected stored procedures one by one with your confirmations.


Delete Queries from Query Log

When a connection to database is made, a “Connected Database” window is created.

Click the “Query Log” tab on the tabbed window on the left side of the “Connected Database” window to display all executed queries on the server and database.  Select one or more queries then press the “Delete” key.  This action will delete all selected queries at once.

You can select the “Clear Executed Query Log” menu item from the “Tools” dropdown menu to clear all executed queries in all query logs.


Delete Reports and Report Groups

In order to delete a report or report group, you must first logon as administrator.  Select a report or report group, then press the “Delete” key.  This action will delete the selected report or report group with your confirmation.


Search a Row in Grid

Enter any character in the grid search edit box that is located at top of each grid to start a search.  Press the “Enter” key to repeat the search.  If a search is successful then the row that was found is highlighted.


Export Content in Grid to HTML or CSV Formats

Select one or more rows in a grid, then right mouse-button click on the grid.  In the popup menu select the “Export Selected Row(s) to HTML Format” menu item to export selected rows in HTML format. In the popup menu select the “Export Selected Row(s) to Comma Delimited Format” menu item to export selected rows in CSV format.


Print Content in Grid on Printer

Select one or more rows in a grid, then right mouse-button click on the grid.  In the popup menu select the “Print Selected Row(s)” menu item to print selected rows on a printer.


Contact Allegro Software

Mailing Address:

Allegro Software, Inc

P.O.BOX 43

Franklin Park, NJ 08823

Web Site:

http://www.allegro-soft.com/

For Technical Support:

Email: support@allegro-soft.com

Web: http://www.allegro-soft.com/support/

Phone: (732) 940-4388

For Sales:

Email: sales@allegro-soft.com

Phone: (732) 940-4388

For Comments, Suggestions and Questions:

Email: comments@allegro-soft.com


Technical Support

For our registered customers, Cute DB Explorer comes with 60-day free technical support.  Support is available by email, on our web site at http://www.allegro-soft.com or by calling (732) 940-4388.  Be sure to have your registration key available when you make support request.

If you have any comments, suggestions or questions, you are welcome to email, call or write to us.  Please see Contact Information for email address, web site and phone numbers.


System Requirement

Cute DB Explorer requires Microsoft Windows 95/98/NT 4.0 and at least 10 MB of disk space.  It also requires ODBC components including ODBC Data Source Administrator and proper ODBC drivers for databases installed.


Uninstall

From the Windows Control Panel double click on Add/Remove Programs, select Cute DB Explorer 3.0 from the program list then click on Add/Remove button.


Click this button to set background color for even rows in the grid.


Click this button to set foreground color for even rows in the grid.


Click this button to set background color for odd rows in the grid.


Click this button to set foreground color for odd rows in the grid.


Click this button to set foreground color in the grid.


Click this button to set background color in the grid.


Click this button to apply changes.


Click this button to reset to default-settings.